This page displays various information about the shootings that occured in 2018. This data was collected from GunViolence.org. The total number of shootings that occured in 2018 is 339 and the total number of lives lost due to shootings is 373. Pompano Beach (Parkland) is the city most impacted (in terms of deaths) by shootings that occurred in 2018 with 17 deaths. The state that lost the most lives in one incident is Florida with 17 deaths.
Casualties are defined as number of injuries and deaths that occured due to an incident. Pompano Beach (Parkland) had the most number of casualties with 34 casualites. Santa Fe had the second most number of casualties.
The table below shows the shows the total casualties due to shootings in 2018, and the number of deaths and injuries as well. From this table we can see which states were affected the most due to shootings in terms of number of deaths, casualties or injuries
| State | Dead | Injured | Casualties |
|---|---|---|---|
| Alabama | 12 | 55 | 67 |
| Arizona | 4 | 5 | 9 |
| Arkansas | 7 | 17 | 24 |
| California | 50 | 136 | 186 |
| Colorado | 9 | 27 | 36 |
| Connecticut | 0 | 8 | 8 |
| Delaware | 5 | 0 | 5 |
| District of Columbia | 2 | 23 | 25 |
| Florida | 48 | 132 | 180 |
| Georgia | 3 | 33 | 36 |
| Illinois | 21 | 150 | 171 |
| Indiana | 10 | 27 | 37 |
| Kansas | 1 | 11 | 12 |
| Kentucky | 7 | 25 | 32 |
| Louisiana | 15 | 50 | 65 |
| Maryland | 13 | 31 | 44 |
| Massachusetts | 0 | 4 | 4 |
| Michigan | 10 | 28 | 38 |
| Minnesota | 1 | 14 | 15 |
| Mississippi | 1 | 17 | 18 |
| Missouri | 12 | 52 | 64 |
| Nebraska | 1 | 16 | 17 |
| Nevada | 3 | 15 | 18 |
| New Jersey | 4 | 54 | 58 |
| New Mexico | 5 | 4 | 9 |
| New York | 5 | 53 | 58 |
| North Carolina | 14 | 37 | 51 |
| Ohio | 13 | 46 | 59 |
| Oklahoma | 2 | 19 | 21 |
| Pennsylvania | 35 | 63 | 98 |
| South Carolina | 5 | 19 | 24 |
| Tennessee | 19 | 68 | 87 |
| Texas | 29 | 62 | 91 |
| Utah | 0 | 4 | 4 |
| Virginia | 2 | 17 | 19 |
| Washington | 4 | 9 | 13 |
| Wisconsin | 1 | 16 | 17 |
This table below only shows the top 5 states that were affected by shootings in 2018 and displays the number of casualties further divided into injuries and deaths for each of the 5 states.
| State | Dead | Injured | Casualties |
|---|---|---|---|
| California | 50 | 136 | 186 |
| Florida | 48 | 132 | 180 |
| Illinois | 21 | 150 | 171 |
| Pennsylvania | 35 | 63 | 98 |
| Texas | 29 | 62 | 91 |
While Florida has the most deaths and casualties in one single incident, from the table above it is clear that California has the highest number of deaths, injuries and casualties from all the shootings that occured in 2018.
We can also see that not all shots are fatal as there is more injuries due to shootings than deaths. However, looking at the table with all the states information present we can see that this is not always the case. Delaware is an example where all casualties were deaths.
I selected this incident by reading the table above and identifying which state had the most number of casualties. The state with the highest number of casualties is California with 186 casualties. Thousand Oaks, California had the highest number of casualites in this state. This incident occured on November 7, 2018 at 99 Rolling Oaks Dr, Thousand Oaks. This unfortunate incident occured at the Borderline Bar & Grill in Thousand Oaks, California around 11pm. The number of casualties were 15 out of which 13 died and 2 were injured.
This visualisation below will show the location of each shooting that occured in 2018 and the size of the marker will be based on the number of casualites (number injured and dead). From this visualisation you should be able to get a view of the locations of shooting incidents, and the relative comparasion of casualties. When you hover over each point the extra information will be provided such as the number of injuries, number of deaths, and the location of the incident.
From this visualisation we can see that,
I wanted to see what is the percentage of death in each state due to shootings. I chose to display the information as a scatterplot as this is a measurment of two continuous variables (death rates and total shootings) so the visually impactful way to display this information is as a scatterplot where the maximum and minimum values are easily identified and you can see the position of one state relative to other states.
To get the death percentage information, I created a new dataframe that only includes, state, number of casualties and number of deaths and a new column that includes death rates (which are calculated using the information provided in the orginal dataset)
From the plot the following insights are evident: